dbPro Connection String
Quote from mazzu001 on February 3, 2019, 8:13 pmI'm sorry if this is not the right place for dbpro questions. I didn't see where to put it.
My question is how to properly use a hosted database. I have tried using connection strings from multiple MySQL database hosts. I have a database on azure, azure provides connection strings but they dont work inside visualNeo Win. I also tried a couple of other hosts just to see if it was strictly an Azure issue. The string I am trying to work with is.
Driver={ODBC Driver 13 for SQL Server};Server=tcp:m****db1.database.windows.net,1433;Database=testdb;Uid=m*****@m****db1;Pwd={your_password_here};Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;
I get a message "Could not find installable ISAM"
If I click OK anyways and reopen the properties window, the string has been formatted like this:
Driver={ODBC Driver 13 for SQL Server}
Server=tcp:m****db1.database.windows.net,1433
Database=testdb
Uid=ma*****@m***db1
Pwd={*******}
Encrypt=yes
TrustServerCertificate=no
Connection Timeout=30What am I doing wrong here? Any help is greatly appreciated
I'm sorry if this is not the right place for dbpro questions. I didn't see where to put it.
My question is how to properly use a hosted database. I have tried using connection strings from multiple MySQL database hosts. I have a database on azure, azure provides connection strings but they dont work inside visualNeo Win. I also tried a couple of other hosts just to see if it was strictly an Azure issue. The string I am trying to work with is.
Driver={ODBC Driver 13 for SQL Server};Server=tcp:m****db1.database.windows.net,1433;Database=testdb;Uid=m*****@m****db1;Pwd={your_password_here};Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;
I get a message "Could not find installable ISAM"
If I click OK anyways and reopen the properties window, the string has been formatted like this:
Driver={ODBC Driver 13 for SQL Server}
Server=tcp:m****db1.database.windows.net,1433
Database=testdb
Uid=ma*****@m***db1
Pwd={*******}
Encrypt=yes
TrustServerCertificate=no
Connection Timeout=30
What am I doing wrong here? Any help is greatly appreciated
Quote from mazzu001 on February 11, 2019, 5:40 amIn case anyone else has some issues (specifically with azure sql db) I was finally successful. You have to do a few preliminary steps before you're able to connect.
- download the proper ODBC driver and install it (check what azure is using - at this time it is using ODBC 17 driver)
- inside NeoDBPro / Open Database choose Advanced Connection Wizard
- Under the Provider Tab use Microsoft OLE DB Provider for ODBC Drivers
- Go to the Azure Portal and then to SQL Databases. Click the database you want to connect to.
- In the Overview click Show database Connection Strings
- Click the ODBC tab and copy the string
- Under the Connection tab in NeoDBPro choose the "use connection string" option and paste the string in there
- you will likely have to manually enter your password into the string
- Enter your login credentials in section 2, even though they are already in the string
- while testing, best to check Allow Saving Password
This way I was able to connect to an azure sql database. I am not certain about all functionality but so far I can create a table (as long as it doesn't contain a picture field)but I haven't tested beyond this.
In case anyone else has some issues (specifically with azure sql db) I was finally successful. You have to do a few preliminary steps before you're able to connect.
- download the proper ODBC driver and install it (check what azure is using - at this time it is using ODBC 17 driver)
- inside NeoDBPro / Open Database choose Advanced Connection Wizard
- Under the Provider Tab use Microsoft OLE DB Provider for ODBC Drivers
- Go to the Azure Portal and then to SQL Databases. Click the database you want to connect to.
- In the Overview click Show database Connection Strings
- Click the ODBC tab and copy the string
- Under the Connection tab in NeoDBPro choose the "use connection string" option and paste the string in there
- you will likely have to manually enter your password into the string
- Enter your login credentials in section 2, even though they are already in the string
- while testing, best to check Allow Saving Password
This way I was able to connect to an azure sql database. I am not certain about all functionality but so far I can create a table (as long as it doesn't contain a picture field)but I haven't tested beyond this.
Quote from farhad2008 on August 8, 2019, 4:53 pmhi,
why neobookdbpro not work on win7 64bit ?
thanks
hi,
why neobookdbpro not work on win7 64bit ?
thanks
Quote from dglojnar on August 8, 2019, 5:21 pmI have bad experience with MSSQL server and DBPro connection, just refuse to connect, no matter which driver, OS etc...
But I think problem is MSSQL, not DBPro, because, ALL other connections, even a complicated one like Oracle Tables, MariaSQL and some exotic SQL databases works without problems....
If someone have solution, I'll be grateful!
I have bad experience with MSSQL server and DBPro connection, just refuse to connect, no matter which driver, OS etc...
But I think problem is MSSQL, not DBPro, because, ALL other connections, even a complicated one like Oracle Tables, MariaSQL and some exotic SQL databases works without problems....
If someone have solution, I'll be grateful!
Quote from dglojnar on August 8, 2019, 5:23 pmQuote from farhad2008 on August 8, 2019, 4:53 pmhi,
why neobookdbpro not work on win7 64bit ?
thanks
I don't know, in my case NebookDBPro/Neobook work without problems in all environments - from XP 'til Windows 10, no matter if Windows are 32 or 64 bit...
Quote from farhad2008 on August 8, 2019, 4:53 pmhi,
why neobookdbpro not work on win7 64bit ?
thanks
I don't know, in my case NebookDBPro/Neobook work without problems in all environments - from XP 'til Windows 10, no matter if Windows are 32 or 64 bit...