is it possible to connect to a SQL Anywhere Server without an existing database to create one. In SQL Anywhere Studio i always have to define an existing database.
Regards Martin
Asked
Active
Viewed 192 times
1 Answers
0
You can use the dbinit utility to create a database without connecting to one. If you really want to connect to a SQL Anywhere server and execute the CREATE DATABASE statement yourself (which is all dbinit does), you can start the personal server (dbeng17) and use the utility database, which is a "virtual" database that always exists. To do this, specify "DBN=utility_db" in your connection string.
Graeme Perrow
- 545
- 1
- 4
- 16
-
Hi, but on the fly with SQL and a login it is not not possible?!? – Martin.Martinsson Oct 23 '17 at 21:14
-
I'm not sure what you mean. I said in my answer that you can use SQL to do it by connecting to the utility database. What exactly are you trying that's not working? – Graeme Perrow Oct 24 '17 at 12:32
-
Hi, tested it, works fine on production server too, not only personal server! Thanks – Martin.Martinsson Oct 24 '17 at 21:21