Re: connection function using odbc with PDO OOP Programming Web Development by rpv_sen MSSQL Re: MySQL or MSSQL Programming Databases by TKSS MSSQL is Microsoft SQL Server ([url="http://www.answers.com/ms+sql&r=67"]http://www.answers.com/ms+sql&r=67[/url]) MySQL is Open Source SQL Server ([url="http://www.answers.com/mysql&r=67"]http://www.answers.com/mysql&r=67[/url]) Re: MySQL or MSSQL Programming Databases by Drew MSSQL is a little more powerfull database server, but it does cost money. Re: Windows Server Config on GoDaddy IIS7 Hardware and Software Microsoft Windows by stormal1 MSSQL db passwords are not stored in the webroot. They are stored in the SQL server itself. If your code has been implemented properly no one can access your stored db connection credentials. You can also create a secured local ODBC connection to a remote server and utilize Microsoft's MSSQL remote administration/management console if you so desire… Re: Getting form data into SQL Programming Web Development by btinney mssql, and so, I don't know wow to write the asp scripts, godaddy has posted the connections scripts necessary to connect, and I looked at them, but not sure how to use them, like I said, this may be over my head, may have to pay someone, but if I can figure it out, I prefer to learn it myself. Thanks Re: Restoring database using c# WinForms Programming Software Development by xxxtian MSSQL EXPRESS 2008 .. Please help me , Re: what is a tinyint in C#? Programming Software Development by sknake MSSQL tinyint is 0-255 (one byte). The C# equivelant data type is [icode]byte[/icode] See: [URL="http://msdn.microsoft.com/en-us/library/ms131092.aspx"]Mapping CLR Data Types[/URL] Re: Why we should use Sql or Access? Programming Software Development by Ancient Dragon >MSSQL is no longer the behemoth it used to be and is actually very fast now. I was referring to SQL-compliant databases in general, not a specific one. MSSQL 2005 Express Restore Backup Issue Programming Databases by oracio Hello, I recently bought a new server and I'm trying to move the MSSQL database from the old mssql (MSSQL 2000) to the new system MSSQL Express 2005. I made a .bak file in the old server and restored it succesfuly in the new server. the thing is that it created a new schema and took the old db user which doesn't exist in the new server. and … Re: MSSQL 2005 Express Restore Backup Issue Programming Databases by zenocide [QUOTE=oracio;428705]Hello, I recently bought a new server and I'm trying to move the MSSQL database from the old mssql (MSSQL 2000) to the new system MSSQL Express 2005. I made a .bak file in the old server and restored it succesfuly in the new server. the thing is that it created a new schema and took the old db user which doesn't exist in … MSSQL Fields Out Of Order Programming Databases by DVHost [COLOR=#000000]For years I have been working with MS Access and enjoying the simplicity and ease of use. I am now making the move and converting all of my sites to MSSQL. Virtually everything works but in the process, I have found an oddity that I am not used to.[/COLOR] [COLOR=#000000]I have a question about fields in an MSSQL DB or any type of … Re: MSSQL Fields Out Of Order Programming Databases by RobStocks [quote=DVHost;301185][COLOR=#000000]For years I have been working with MS Access and enjoying the simplicity and ease of use. I am now making the move and converting all of my sites to MSSQL. Virtually everything works but in the process, I have found an oddity that I am not used to.[/COLOR] [COLOR=#000000]I have a question about fields in an … mssql connection problem with PHP Programming Databases by php2sheik i want to connect mssql(microsoft sql server 2005) using php, when i connect the following error displayed. why this error mssql_connect() [function.mssql-connect]: Unable to connect to server: note:in my system mssql 2005 is not installed..i connect another db which is in another system connected through LAN. if i connect the sqlserver … MSSQL connection strings Programming Databases by hanifa Hi, I am using MSSQL (Microsoft SQL)to liase with python via third party driver. Well here goes... I have created two instances of SQL registration in my Enterprise manager. It is under i)Console Root->Microsoft SQL Servers->SQL Server Group->(LOCAL)(Windows NT) and ii)Console Root->Microsoft SQL Servers->SQL Server Group->… mssql walkthrough Programming Databases by aasahi Hi, I'm a newbie in MSSQL. But i already tried using mysql. How can I create a database in mssql. I mean what would be the first step. I had installed Microsoft SQL Server 2005 along with Microsoft Visual C# Express Edition. The following are the tools found in Start>Program Files>Microsoft SQL Server 2005> Configuration Tools: - SQL … MSSQL datetime format Programming Databases by akronymn I have an mssql database that I need to migrate to mysql. For some reason though any queries to any columns of type datetime are returned in French in the following format: 7/avr/2004 14:00 This also includes all the text of an SQL dump which not surprisingly makes mysql unable to read the dump from the MSSQL db. I've checked that my … MSSQL Server problem writing VARBINARY data. Programming Databases by LED555 I'm trying to INSERT a zip file into an MSSQL table. The table structure is such: [CODE]CREATE TABLE [dbo].[zips]( [id] [int] IDENTITY(1,1) NOT NULL, [timestamp] [varchar](50) NULL, [inserted] [varchar](50) NULL, [filename] [varchar](50) NULL, [raw_file] [varbinary](max) NULL ) ON [PRIMARY][/CODE]...nothing too fancy. When I … MSSQL Mirroring two servers Programming Databases by gvwiberg Hello I'm working a website that is going to be very,very critical. For now, there is one MSSQL 2005 database online. I'm trying to figure out how to setup mirroring for two MSSQL Servers. (Like two mirrored servers) I understand that you can setup a mirroring like "Server", "Server backup" and "Witness" and the … Re: MSSQL connection strings Programming Databases by hollystyles db=MSSQL.connect('INTEL\FR6EnterpriseDB','sa','','SecondDBase') try this, I'm an ADO user so not sure about Python, but the theory should be the same. You see both databases are listening on that IP address 193.168.1.111, which is synonymouse with 'INTEL', the only way to differentiate is that the server with no name is the default and the other… Re: MSSQL connection strings Programming Databases by hanifa [quote=hollystyles]db=MSSQL.connect('INTEL\FR6EnterpriseDB','sa','','SecondDBase') try this, I'm an ADO user so not sure about Python, but the theory should be the same. You see both databases are listening on that IP address 193.168.1.111, which is synonymouse with 'INTEL', the only way to differentiate is that the server with no name is the … Re: MSSQL connection strings Programming Databases by hanifa Hi it is solved.. the linux problem... I never knew MSSQL uses different port for every instance...dats it... Bottom line: U must specify ur port number in ur connectionstring.. Cheers MSSQL - MySql Database Connectivity Programming Databases by sb2008 Hi, A third party development company is creating a third party application for us in PHP and uses a MYSQL database. The app is an extension of our website which is developed in .NET and uses a MSSQL 2005 database. There are some cases where the two databases require connectivity since a few fields need to relate. We are having issues … MSSQL Concurrency Programming Databases by AIexplorer I have several questions: Here is the context: The ASP.NET application I'm building - a web service in essence - will be connecting to MSSQL to log requests to a table. These are basic INSERT commands. During high-volume hours, do I risk race conditions? How does MSSQL handle sequential INSERT queries? What about when there are multiple users… MSSQL "A network-related or instance-specific error" and IIS application pool Programming Databases by johnyjj2 Hello! I've got web application created for MSSQL and IIS. There are two directories in this application - Scripts and WebSite. In Script there is file CreateDb.sql. I need to run it so that it can create database. I changed in that file one line into this: CREATE DATABASE [NameOfDb] ON PRIMARY ( NAME = N'NameOfDb', FILENAME = N'F:\Inetpub\… MSSQL HELP (mdb to sql) Programming Databases by synfist Hi I have zero knowledge about sql,databases,mssql etc etc. I have installed MSSQL 2005 express edition. What i need i have two access files say data1.mdb and data2.mdb. i need to create a database database1 which has tables from both data1.mdb and data2.mdb. Please tell me how i can do it . Please tell me in … mssql question Programming Databases by ZER09 can any one tell if there existing database administration tools like mysql workbench but for mssql i know about sql management studio, but there is other one who will manage mssql other than SSMS? I will appreciate for any help will come. thank you. mssql to mysql Programming Databases by kuubay hi...is there anybody who has the right software for converting MSSQL to MYSQL?maybe u can share with me? please help coz im still very new to these fields. Re: mssql to mysql Programming Databases by nagramana I have developed my own mssql to mysql converter software. Before sending to you can you giveme your personnal mail id with address. Ramana MSSql 2000 Unable to insert into database Programming Databases by kokkee hi, i am using vs.net 2003 and mssql 2000. currently my db size is 2.5gb including DB transaction Log File. For (.BAK extension) is 1.55 gb. May i know how to expand or improve my DB because when it reach the size (2.5GB). i will always get error message : Unable to insert into database. So, i need to purze my DB record to avoid it to have… MSsql to MySql - cronjobing Programming Databases by davidcitron Hello all, i have got an issue with a client here, who is running an internal CRM system. we need to get information into our Webserver (Linux-MySQL5) database (dealer lists, product lists, ....) and this information is stored in the CRM. but the CRM is Windows-MSsql. The output is .DAT files. I understand extracting a .DAT file on my MySql …